Carson Penticuff
Carson Penticuff
Reactions
-
Re: Use a picture as an icon and then when you click it's bigger?
You can add it as a picture widget, set to "fill" and then resize as needed. If you double click the image, it will open a larger version.1 · -
Re: COUNTIF where counting if cell contains "Super" but "Superstar"
If I am understanding your request correctly, this should work: =COUNTIFS({Status}, Product@row, {Title}, CONTAINS("Super", @cell), {Title}, NOT(CONTAINS("Superstar", @cell)))1 · -
Re: Hours:Minutes:Seconds reported by consultant at $/hour calculated to the hr/min/sec used
Depending on where you are pulling the number or hours and hourly rate from, this will need to be adjusted somewhat to fit your use case. =Rate@row * (IF(LEN(Hours@row) > 5,(VALUE(Left(Hours@row, …1 · -
Re: Counting people
=COUNT(DISTINCT(COLLECT([Employee]:[Employee], [Activity]:[Activity], "X")))1 · -
Re: Counting people
=COUNT(DISTINCT([Employee]:[Employee])) Replace [Employee] if your column has a difference name. This will essentially generate a list of distinct entries and then count them.1 ·
